Daily Invoice Export - Credit Block

Terminology

Record Set

A set of rows exported into the CSV file, it consists of the records in the order as in below Order Indicator Context 1.x TH Transaction Header 2.x RE Supplier/Repairer Details 3.x IN Invoice Credit Note Details 4.x.1 IL Item Line Details 4.x.2.n IP Parts Record 4.x.3 TL Total Line Cost Record 5.x TC Total Transaction Cost Record 6.x VA VAT Summary Record 7.x TT Transaction Trailer Record * x denotes an index of the transaction relative to the enquiry that is invoiced/credited on the day of export * n denotes an index of parts/fluids added in a job line of specific enquiry

Record

A particular line of the export that is either of indicators allowed in a record set, along with one record for the entire file among the following HE - File Header LC - Scheme Operator Address Detail FT - File Trailer Record

File Header - HE

• This record is mandatory
• This is the first line of the export file
• This line is not part of any record set, it is common for the entire file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. HE - File Header This record is required for every export file Only one such record is allowed per file This line is not part of any record set, it is common for the entire file.	Text	2	Must be "HE"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Scheme Operator Reference	Integer	7	ViSN Customer Account Number	Y
4	Type of Transaction	Text	1	Value must be "I" The export process combines both invoices and credits into a single file. However, in the HE Record, the "Transaction Type" field does not distinguish between them and always displays "Invoice". In the HE Record, the "Transaction Type" field serves as an indicator of the file format for export, rather than specifying the actual transaction type (invoice or credit).	Y
5	File Serial Number	Integer	8	Retrieve the baseReferenceDate and baseSequenceNumber from Firebase at the following location: - leasecompany {leaseId} exports settings invoiceExportsSequenceNumber baseReferenceDate baseSequenceNumber Determine days elapsed as number of days between the baseReferenceDate and the current date Add baseSequenceNumber to it to use it as the export sequence number	Y
6	Run Date	Integer	8	CCYYMMDD (e.g., "20031225")	Y
7	Run Time	Integer	6	HHMMSS (e.g., "232830")	Y
8	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Scheme Operator Address Detail - LC

• The inclusion of this line is controlled by the flag addLCLineForInvoice, which is configured in the lease company's scheduler.
• When addLCLineForInvoice is set to false, the LC line appears only once in the file.
• When addLCLineForInvoice is set to true, the LC line is included for each record in the file.
• If addLCLineForInvoice is not configured in the lease company's scheduler, the LC line defaults to being included for each record in the file.
• It provides details about the customer for whom the export is being generated.

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. LC - Lease Company (or) Operator (or) Scheme Operator Address Detail This record is mandatory for each record set. Only one such record is allowed per file. It includes details about the customer for whom the export is generated.	Text	2	Must be "LC"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Scheme Operator Reference	Integer	7	ViSN Customer Account Number This value will be fetched into the column at the time of export from below location in firebase - leasecompany {leaseId} leaseDetails accountNumber The value will be blank in case of the value being not present in above location	Y
4	Scheme Operator Account Name	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' If Group level setting, 'Use Direct Paybill Name' is enabled Then, Savi Perfix and Lease Company's Name for Direct Paybill will be used If Group level setting, 'Use Direct Paybill Name' is disabled Then, Savi Perfix and Lease Company's Name will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' If Group level setting, 'Use Direct Paybill Name' is enabled Then, Lease Company's Name for Direct Paybill will be used If Group level setting, 'Use Direct Paybill Name' is disabled Then, Lease Company's Name will be used For other rate card types, the value will default to the lease company's name. The name to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} leaseCompanyName	Y
5	Scheme Operator Address 1	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address	Y
6	Scheme Operator Address 2	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address	Y
7	Scheme Operator Address 3	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
8	Scheme Operator Address 4	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
9	Scheme Operator Address 5	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
10	Scheme Operator Postcode	Text	8	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
11	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Transaction Header - TH

• Record is mandatory for each transaction in the record set
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TH - Transaction Header Record is mandatory for each transaction in the record set More than one record can exist in each file	Text	2	Must be "TH"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	ViSN Enquiry Number	Integer	8	The enquiry number must be 8 digits long. If it is shorter, leading zeros should be added. For example, the number "10281" should be represented as "10010281" after padding. Examples: "10006234" for enquiry number 6234 "10000028" for enquiry number 28 In other words, a static value of "10000000" is added to the enquiry number to ensure it is 8 digits long.	Y
4	Invoice Extract Analysis Ref	Integer	2	Constant "01"	Y
5	ViSN Enquiry Number	Text	10	The enquiry number will be populated into this column
6	Vehicle Registration	Text	14	This column will contain the VRM (Vehicle Registration Mark) of the vehicle associated with the enquiry or job.	Y
7	Odometer Reading	Integer	7	This column indicates the vehicle's mileage recorded during the repair.	Y
8	Transaction Date	Integer	8	This column will contain the vehicle's check-in date at the garage. CCYYMMDD (e.g., "20031225")	Y
9	Asset Number	Text	10	This column will contain the asset number associated with the vehicle in the enquiry.	Y
10	Card Number	Text	19	Blank Space
11	Driver Name	Text	40	This column will contain the name of the driver associated with the vehicle in the enquiry
12	Purchase Order Number	Text	20	Mandatory if job authorised on the ViSN platform. Purchase Order that is captured in enquiry will be populated into this column
13	Transaction Serial Number	Integer	8	Constant '1'	Y
14	Job Completion Date	Integer	8	The date when the job was closed and marked as 'Job Complete'. CCYYMMDD (e.g., "20031225").	Y
15	VIN	Text	20	This column will contain the Vehicle Identification Number (VIN) associated with the vehicle in the enquiry.
16	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Supplier/Repairer Details - RE

• This record is required in every record set
• Only one record is allowed per transaction
• Includes details of the supplier responsible for the service related to the enquiry

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. RE - Repairer Entry / Supplier Details This record is mandatory in every record set Only one record is permitted per transaction It contains the details of the supplier responsible for performing the service related to the enquiry	Text	2	Must be "RE"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	ViSN Repairer Account Number	Integer	7	DI Group Supplier ID, if no group then DI Supplier ID The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} groupId	Y
4	Supplier Account Number	Text	20	Supplier Group ID, if no group then Supplier ID The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} serviceUnits {serviceUnitObjectID} supplierId	Y
5	Supplier Account Name	Text	30	Supplier Name from Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier. If the content for this column is found to be more than 30 characters in length, it will be trimmed down to 30 characters.	Y
6	Supplier Account Address 1	Text	30	number from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	Y
7	Supplier Account Address 2	Text	30	address1 from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	Y
8	Supplier Account Address 3	Text	30	address2 from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.
9	Supplier Account Address 4	Text	30	county from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.
10	Supplier Account Postcode	Text	8	postcode from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.
11	Supplier VAT number	Text	10	VAT Number from Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	Y
12	Scheme Operator Controller ID	Text	10	Constant Blank
13	Supplier Account Address 5	Text	30	Constant Blank
14	Contact Telephone Number	Text	15	Contact phone number The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} serviceUnits {serviceUnitObjectID} contact
15	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Invoice Credit Note Details - IN

• This record is required in every record set
• Each transaction can contain only one record
• Multiple records may exist within a single file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IN - Credit Note Details This record is required in every record set Each transaction can contain only one record Multiple records may exist within a single file	Text	2	Must be "IN"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Transaction Type	Text	1	C = Credit	Y
4	Invoice Number	Text	20	This value is retrieved from the credit invoice number recorded in the credit drawer during crediting.	Y
5	Tax Point Date	Integer	8	The value is retrieved from the credit date recorded in the credit drawer during crediting. CCYYMMDD (e.g., "20031225")	Y
6	Repairer Invoice Text	Text	16	Constant Blank
7	Original Invoice Number	Text	20	This value is retrieved from the invoice number recorded in the invoice drawer during invoicing.	Y
8	Original ViSN Transaction Number	Integer	8	The value will be the enquiry number	Y
9	Reason for Credit	Text	30	This value is fetched from the credit reason recorded in the credit drawer.	Y
10	Scheme Operator Message	Text	80	- Not In Use
11	Scheme Operator Authorisation Code	Text	10	Blank - Not In Use
12	Invoice Date	Integer	8	The date on which the credit is generated CCYYMMDD (e.g., "20031225")	Y
13	Terms Status	Text	1	Constant 'I', I denotes `In terms` here
14	End of record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Item Line Details - IL

• Each record set must contain at least one record
• Multiple records can exist within a single transaction and in the export file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IL - Item Line Details Each record set must include at least one record. Multiple records can be present within a single transaction. Multiple records can also exist within a single file.	Text	2	Must be "IL"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Item Number	Integer	2	This column represents the position or sequence of the specific job item within the job sheet linked to the enquiry.	Y
4	Cost Type	Text	1	Will be one of the Cost Types Cost Types F Free No charge for line (non-warranty) M Menu Price No parts/Labour split N Normal separate labour cost and parts cost W Warranty free, paid by manufacturer. T Paid for by third party Exception: For Tyre job lines, this value will always be 'M'.	Y
5	Charge Indicator	Text	1	Will be one of the Recharge Indicators Recharge Indicators P Post Warranty W Warranty R Recharge	Y
6	Quantity	Number	2.2	Value is always 1.	Y
7	Additional Information Text (or) Repairer Authorisation Text	Text	30	This column captures the customer's reason when manually authorizing a job line.
8	External Code/ViSN Job Code	Text	5	Integration code to be used in invoice exports. SMR Joblines: If the includeExternalSMRCodesInExport flag is enabled for the lease company and a matching External SMR Code is found for the jobline's description, it will be applied. This flag can be managed via the DI Admin portal on the Edit Customer screen. MOT Joblines: 28165 will be the code used for these joblines TYRE Joblines: 29128 will be the code used for these joblines SUPPLEMENTARY Joblines: 29113 will be the code used for these joblines GLASS Joblines: Existing external code saved against the job descriptions will be used If external code is not available for the job description in any of the above cases then '0'
9	Job line-Item Description	Text	90	Description of the Jobline Item. The values for this field differ based on the job line type (details provided below) MOT: Will be constant 'MOT' TYRE: A Concatenated string of Description, Brand of tyre and locations of replacement GLASS: A Concatenated string of Description, Location of Glass Change OTHER: Description of the jobline
10	Asset ID	Text	40	The asset number of the vehicle associated with the enquiry will be populated into this column
11	Full Recharge Text	Text	150	Always blank for a credited jobline
12	Action code	Text	3	Default on file is code R&R
13	Reason Code	Text	3	The values for this field differ based on the job line type (details provided below) MOT: Will be constant 'RTN' denoting routine OTHER: Will be one of the Reason Codes Reason Codes 001 Below Legal Limit 002 Run Flat 003 Puncture Damage 004 Sidewall Damage 005 Driver Request 006 Tracking Damage 007 Logistics ACC Accident Damage I Administration Charge CRD Corroded CRQ Client Request CTM Contaminated DAB Abuse DAM Damage DEF Defective DST Distorted EMG Emergency FUL Fuel INS Insurance INT Initial INV Investigation LKG Leaking LOW Low Level LSE Loose LST Lost, originally supplied MSG Missing NGC Negligence NSY Noisy PKF Parking Fine PUN Puncture RCL Recall RLF Relief RTN Routine STF Stress Fracture STL Stolen STN Stone Damage STS Seasonal Tyre Swap SZD Seized UPG Upgrade VIB Vibration VND Vandalism WRN Worn WTH Weather WTY Warranty	Y
14	Goodwill Percentage	Number	3.2	Always 0.0	N
15	Labour Time	Number	5.2	When Cost Type is "N", is mandatory Will be always set to 0 for TYRE joblines This Column will be populated from labour details modal of the jobline (e.g., 99999.99)	Y
16	Labour Rate	Number	5.2	When Cost Type is "N", is mandatory Will be always set to 0 for TYRE joblines This Column will be populated from labour details modal of the jobline The labour rate is calculated by factoring in the goodwill percentage. This ensures that the final rate reflects any adjustments or considerations related to goodwill. (e.g., 99999.99)	Y
17	Number of Parts	Number	3.2	When Cost Type is "N", is mandatory The values for this field differ based on the job line type and job description type (details provided below) TYRE: Will be constant 0 MOT: Will be constant 0 OTHER - Catalogue: Will be constant 0 OTHER - Non Catalogue: Represents the number of parts being credited for a jobline. (e.g., 999.99)	Y
18	Recharge Reason Code	Text	5	Always blank for a credited jobline
19	Recharge Amount	Number	5.2	Always 0.00 for a credited jobline
20	Recharge Percentage	Number	3.2	Always 0.00 for a credited jobline
21	Recharge Text	Text	40	Always blank for a credited jobline
22	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Parts Record - IP

• Record is optional, available only if any of the job lines of the job sheet has parts/fluids added to them
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IP - Invoice (or Credit) Parts details / Parts Record Record is optional in each record set More than one record can exist in each transaction More than one record can exist in each file	Text	2	Must be "IP"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Item Number	Integer	2	This column indicates the specific job item's position (order) within the job sheet associated with the enquiry.	Y
4	Parts Number	Integer	1	Always "1"	Y
5	Parts Code	Text	24	During data export, the 'Part line type' field is used to determine the content for this specific column. If the type is identified as 'P' (indicating a part), the corresponding part number is included If the type is identified as 'F' (indicating a fluid), the corresponding fluid code is placed in the column. the code would be one among available Fluid Types Fluid Types Code Label 0W20_ENGINE_OIL 0w20 Engine Oil 0W30_ENGINE_OIL 0w30 Engine Oil ADDATIVE_POUCH Addative Pouch ADDITIVE_POUCH Additive Pouch AIR_CONDITIONING_COOLANT Air Conditioning Coolant ANTIFREEZE Anti Freeze AUTOMATIC_TRANSMISSION_FLUID Automatic Transmission Fluid AXLE_OIL Axle Oil BRAKE_FLUID Brake/Clutch Fluid COOLING_LIQUID Cooling Liquid DPF_FLUID D.p.f. Fluid AD_BLUE Diesel Exhaust Fluid/AdBlue GEARBOX_OIL_MINERAL Gearbox Oil - Mineral GEARBOX_OIL_SYNTHETIC Gearbox Oil - Synthetic HYDRAULIC_FLUID Hydraulic Fluid LONG_LIFE_OIL Long Life Oil MINERAL_OIL Mineral Oil OIL_1615099980 Oil-1615099980 OIL_9734S2 Oil-9734S2 OIL_9979A7 Oil-9979A7 OTHER Other PARTIULATE_FLUID Partiulate Fluid POWER_STEERING_FLUID Power Steering Fluid REFRIGERATOR_COOLANT Refrigerator Coolant SEMI_SYNTHETIC_1 Semi Synthetic Oil SEMI_SYNTHETIC_2 Semi Synthetic Oil SUSPENSION_FLUID Suspension Fluid SYNTHETIC_1 Synthetic Oil SYNTHETIC_2 Synthetic Oil SYNTHETIC_3 Synthetic Oil SYNTHETIC_ANTI_POLLUTION_5W_30_ENG_OIL Synthetic Anti Pollution 5w-30 Eng Oil UREA Urea WASHER_LIQUID Washer Liquid
6	Parts Description	Text	30	During data export, the 'Part line type' field is used to determine the content for this specific column. If the type is identified as 'P' (indicating a part), the corresponding part name is included If the type is identified as 'F' (indicating a fluid), the corresponding fluid label is placed in the column. the code would be one among available Fluid Types Fluid Types Code Label 0W20_ENGINE_OIL 0w20 Engine Oil 0W30_ENGINE_OIL 0w30 Engine Oil ADDATIVE_POUCH Addative Pouch ADDITIVE_POUCH Additive Pouch AIR_CONDITIONING_COOLANT Air Conditioning Coolant ANTIFREEZE Anti Freeze AUTOMATIC_TRANSMISSION_FLUID Automatic Transmission Fluid AXLE_OIL Axle Oil BRAKE_FLUID Brake/Clutch Fluid COOLING_LIQUID Cooling Liquid DPF_FLUID D.p.f. Fluid AD_BLUE Diesel Exhaust Fluid/AdBlue GEARBOX_OIL_MINERAL Gearbox Oil - Mineral GEARBOX_OIL_SYNTHETIC Gearbox Oil - Synthetic HYDRAULIC_FLUID Hydraulic Fluid LONG_LIFE_OIL Long Life Oil MINERAL_OIL Mineral Oil OIL_1615099980 Oil-1615099980 OIL_9734S2 Oil-9734S2 OIL_9979A7 Oil-9979A7 OTHER Other PARTIULATE_FLUID Partiulate Fluid POWER_STEERING_FLUID Power Steering Fluid REFRIGERATOR_COOLANT Refrigerator Coolant SEMI_SYNTHETIC_1 Semi Synthetic Oil SEMI_SYNTHETIC_2 Semi Synthetic Oil SUSPENSION_FLUID Suspension Fluid SYNTHETIC_1 Synthetic Oil SYNTHETIC_2 Synthetic Oil SYNTHETIC_3 Synthetic Oil SYNTHETIC_ANTI_POLLUTION_5W_30_ENG_OIL Synthetic Anti Pollution 5w-30 Eng Oil UREA Urea WASHER_LIQUID Washer Liquid If the content for this column is found to be more than 30 characters in length, it will be trimmed down to 30 characters.	Y
7	Quantity	Number	2.2	Always '1' for credited part or fluid line, this is because the credit is issued against invoiced part value which is already product of quantity and unit price	Y
8	Unit Price	Number	5.2	The credited amount corresponding to the part or fluid line. e.g. 99999.99	Y
9	Parts Discount Rate	Number	3.2	Always '0.00' for credited part or fluid line	Y
10	Goodwill Percentage	Number	3.2	Always '0.00' for credited part or fluid line	N
11	Discounted Unit Price	Number	5.2	The credited amount corresponding to the part or fluid line after applying the discount percentage. Since the discount percentage is always '0.00' for credited parts or fluid lines, the unit price remains identical to the value in IP8.	Y
12	Nett Parts Price	Number	5.2	Indicates the net price of the part line. The net price is derived by calculating the total cost (line credit value multiplied by quantity), then deducting the unit discount and the goodwill discount. However since the unit and goodwill discounts are always '0.00' and the quantity is always '1', the net price is equivalent to the line credit value (IP11). (e.g., 99999.99)	Y
13	VAT Rate	Number	2.2	Mandatory with Credit Note (e.g. 99.99)
14	Normal Part	Text	1	constant 'Y' is exported. “Y” = Yes “N” = No	Y
15	Manufacturer of Part	Text	3	constant blank is exported. Mandatory if Normal Part = “N”, however ViSN never exports N for now
16	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
17	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Total Line Cost Record - TL

• At least one record must exist in each record set
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TL - Total Line Cost At least one record must exist in each record set for an invoice or credit More than one record can exist in each file as more than one record sets are allowed in one file	Text	2	Must be "TL"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Nett Labour Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Will be constant 0 TYRE: Will be constant 0 OTHER - Catalogue: Will be constant 0 OTHER - Non Catalogue: The net labor cost for each labor line is determined by applying the goodwill percentage to the credit value of the labor line. Since the goodwill percentage is assumed to be 0 (as credit is issued on the invoiced value), the credit value is equal to the net labor cost. (e.g., 99999.99)	Y
4	VAT Rate Labour	Number	2.2	Mandatory only with an invoice or credit note. (e.g., 99.99)	Y
5	Total Nett Parts Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Will be constant 0 TYRE: Will be constant 0 OTHER: For Catalogue descriptions that don't belong to FNP, This field will be set to a constant value of 0. For Catalogue descriptions that belong to FNP (i.e., OEM descriptions), are treated as having a net price of zero. Consequently, the total net price for these lines will also be zero. On top of this sum, the menu price for the OEC description is added For Non-Catalogue descriptions that do or don't belong to FNP, The export process calculates the net parts cost by accumulating the credit value from each part line. Note: Non-Catalogue descriptions that belong to FNP are originated from MODULUS (e.g., 99999.99)	Y
6	Total Nett Line Cost	Number	5.2	The final cost is calculated differently depending on the description type. For non-catalogue descriptions, it's the sum of net labor and parts credit values from individual lines. (e.g., 99999.99)	Y
7	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
8	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Total Transaction Cost Record - TC

• Must exist in each record set
• Only one record per Transaction
• More than one record can exist in an export file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TC - Transaction Cost(total) Record A mandatory Record for each of the record set, credit/invoice More than one record can exist in each file as more than one record sets are allowed in one file	Text	2	Must be "TC"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Total Nett Labour Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Will be constant 0 TYRE: Will be constant 0 OTHER - Catalogue: Will be constant 0 OTHER - Non Catalogue: The net labor cost for each labor line is determined by applying the goodwill percentage to the credit value of the labor line. Since the goodwill percentage is assumed to be 0 (as credit is issued on the invoiced value), the credit value is equal to the net labor cost. (e.g., 99999.99)	Y
4	Total Nett Parts Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Will be constant 0 TYRE: Will be constant 0 OTHER: For Catalogue descriptions that don't belong to FNP, This field will be set to a constant value of 0. For Catalogue descriptions that belong to FNP (i.e., OEM descriptions), are treated as having a net price of zero. Consequently, the total net price for these lines will also be zero. On top of this sum, the menu price for the OEC description is added For Non-Catalogue descriptions that do or don't belong to FNP, The export process calculates the net parts cost by accumulating the credit value from each part line. Note: Non-Catalogue descriptions that belong to FNP are originated from MODULUS (e.g., 99999.99)	Y
5	Total Nett Transaction Cost	Number	5.2	TThe final cost is calculated differently depending on the description type. For non-catalogue descriptions, it's the sum of net labor and parts credit values from individual lines. (e.g., 99999.99)	Y
6	VAT Amount	Number	5.2	Mandatory with an invoice or credit note (e.g., 99999.99)
7	Total Gross Labour Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net labor cost and applying the VAT rate (e.g., 99999.99)
8	Total Gross Parts Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net parts cost and applying the VAT rate (e.g., 99999.99)
9	Total Gross Transaction Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net jobline cost and applying the VAT rate (e.g., 99999.99)	Y
10	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

VAT Summary Record - VA

• One record per VAT code in each Transaction
• More than one record can exist in a file
• More than one record can exist in a Transaction

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. VA - VAT summary Record	Text	2	Must be "VA"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	VAT Rate	Number	2.2	(e.g., 99.99)	Y
4	VAT Applicable Amount	Number	5.2	(e.g., 99999.99)	Y
5	VAT Amount	Number	5.2	Represents the total VAT amount for all joblines associated with the specified VAT code. (e.g., 99999.99)	Y
6	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
7	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Transaction Trailer Record - TT

• One record must exist for each Transaction
• More than one record can exist in an export file

Sr.No	Field Label	Format	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TT - Transaction trailer Record	Text	2	Must be "TT"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Number of Records	Integer	5	Total number of records between Transaction Header and Transaction Trailer inclusive (excludes authorisation details)	Y
4	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

File Trailer Record - FT

• This record is mandatory
• This line does not belong to a record set, instead common for the whole file

Sr.No	Field Label	Format	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TC - File Trailer Record	Text	2	Must be "FT"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Number of Records	Integer	5	Total number of transactions	Y
4	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Status: Accepted
Category: Protected
Authored By: Rama on 02 April 2025

Revisions
02 Apr, 2025 - Add separate documentation for credit block in Daily Invoice Export.
03 Apr, 2025 - Create and reuse lines that are identical in credit and invoice export.
04 Apr, 2025 - Create documentation for lines that source information from different location to export.
07 May, 2025 - Update the calculations along with the diagrams representing how they are calculated.
09 May, 2025 - Revise Lease Company name column based on Paybill value and Direct Paybill name setting, VN-18231